/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package org.trandio.dao;

import java.sql.SQLException;
import java.util.Date;
import java.util.List;
import javax.naming.NamingException;
import org.trandio.model.MedicoVO;
import org.trandio.model.TurnoVO;


/**
 *
 * @author root
 */
public interface MedicoInterface {    
      public List<MedicoVO> consultarMedico(String identificacion, String nombre1, String nombre2, String apellido1, String apellido2, int firstRow, int rowsPerPage, String sortField, boolean sortAscending) throws SQLException, NamingException;
      public int count() throws SQLException, NamingException;
      public MedicoVO getMedico(int id) throws SQLException, NamingException;
      public int guardarMedico(MedicoVO medicoVO) throws SQLException, NamingException;
      public void guardarMedicoEdit(MedicoVO medicoVO) throws SQLException, NamingException;
      public void crearTurno(int id, Date fecha_cita,Date fecha_cita1, String hinicio, String hfin, int tiempo, int turnos, int sede,String Listasemana, String Listafestivo) throws SQLException, NamingException;
      public List<TurnoVO> consultarTurnos(int id, int id_sede) throws SQLException, NamingException;
      public void quitarTurno(int id_turno)  throws SQLException, NamingException;
      public List<MedicoVO> consultarMedicoEspecialidad(int id_especialidad) throws SQLException, NamingException;
      public List<MedicoVO> consultarMedico(String identificacion, String nombre, String apellido) throws SQLException, NamingException;
      public boolean  validarTurno(int medico, Date fecha, Date fecha1, String hinicio, String hfin, int sede) throws SQLException, NamingException;
      public int validarCita(int turno) throws SQLException, NamingException;

    public int getCantMedicos(String $sWhere) throws SQLException, NamingException;
    public List<MedicoVO> getMedicos(int displayStart, int displayLength, String $sWhere, String orden) throws SQLException, NamingException;

    public List traerTurnos(int parseInt);
}